Home > Tips > Connection String > DBF and FoxPro
DBF and FoxPro Connection Strings
FoxPro and DBF Connection Strings including ODBC, OLE DB and SQL Client Connection Strings.
This is the complied and tested collection of DBF and FoxPro Connection strings including
FoxPro and DBF ODBC Standard Security Connection String, Trusted connection, OLE DB, OleDbConnection (.NET) Standard Security Connection Strings, Connecting to an FoxPro and DBF File
ODBC Connection
String for FoxPro and DBF |
|
Standard Security |
|
|
Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\mydbpath;
|
|
|
oConn.Open "Driver={Microsoft dBASE Driver
(*.dbf)};" & _
"DriverID=277;" & _
"Dbq=c:\somepath"
Then specify the filename in the SQL statement:
oRs.Open "Select * From user.dbf", oConn, , ,adCmdText
|
|
|
|
OLE
DB, OleDbConnection (.NET) Connection String for
FoxPro and DBF |
|
Standard Security |
|
|
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\folder;Extended
Properties=dBASE IV;User ID=Admin;Password=;
|
Home > Tips > Connection String > DBF and FoxPro